/**
 * 项目树形菜单查询
 */
'use strict';

const conn = require('../../libs/DB/Conn');

module.exports = async function (params) {
    let result = await conn(`
            SELECT
                project_id AS projectId,
                project_name AS projectName,
                population,
                area
            FROM
                project_file
            WHERE
                delete_sign = 1
            AND domain_id = ${params.userDomainId}`);

    return { success: true ,dataList:result};
};